SELECT FORMMAIN_1671."ID",ORG_MEMBER.CODE usercode,CTP_ENUM_ITEM.ENUMVALUE glbdef1,
"TO_CHAR"(FORMMAIN_1671.FIELD0023,'yyyy-mm-dd hh24:mi:ss') glbdef2
FROM COL_SUMMARY
LEFT JOIN FORMMAIN_1671 ON FORMMAIN_1671."ID" = COL_SUMMARY.FORM_RECORDID
LEFT JOIN ORG_MEMBER ON ORG_MEMBER."ID" = FORMMAIN_1671.FIELD0001
LEFT JOIN CTP_ENUM_ITEM  ON CTP_ENUM_ITEM."ID" = FORMMAIN_1671.field0017
WHERE COL_SUMMARY."ID" = '${id}'